﻿CREATE TABLE [Core].[Page] (
    [PageId]          UNIQUEIDENTIFIER ROWGUIDCOL NOT NULL,
    [BusinessUnitId]  UNIQUEIDENTIFIER NOT NULL,
    [PermissionId]    UNIQUEIDENTIFIER NOT NULL,
    [PageName]        NVARCHAR (127)   NOT NULL,
    [Title]           NVARCHAR (127)   NOT NULL,
    [ShowTitleYN]     NCHAR (1)        NOT NULL,
    [MetaKeywords]    NVARCHAR (255)   NOT NULL,
    [MetaDescription] NVARCHAR (255)   NOT NULL,
    [ContainerId]     UNIQUEIDENTIFIER NOT NULL,
    [OnMainMenuYN]    NCHAR (1)        NOT NULL,
    [IsTemplateYN]    NCHAR (1)        NOT NULL,
    [IsDroppedYN]     NCHAR (1)        NOT NULL,
    [CreateDT]        DATETIME         NOT NULL,
    [CreatedById]     UNIQUEIDENTIFIER NOT NULL,
    [CreatedByName]   NVARCHAR (127)   NOT NULL,
    [ModifiedDT]      DATETIME         NOT NULL,
    [ModifiedById]    UNIQUEIDENTIFIER NOT NULL,
    [ModifiedByName]  NVARCHAR (127)   NOT NULL
);

